/*
Navicat MySQL Data Transfer

Source Server         : aliyun_mqp
Source Server Version : 80027
Source Host           : 139.196.8.79:3306
Source Database       : stu

Target Server Type    : MYSQL
Target Server Version : 80027
File Encoding         : 65001

Date: 2022-04-13 15:50:29
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
`id`  int NOT NULL AUTO_INCREMENT ,
`title`  varchar(222) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ,
`body`  varchar(222) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ,
`create_by`  int NULL DEFAULT NULL ,
`lastmodified_by`  varchar(222) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ,
`update_time`  mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL ,
`create_time`  mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
AUTO_INCREMENT=13

;

-- ----------------------------
-- Records of article
-- ----------------------------
BEGIN;
INSERT INTO `article` VALUES ('1', '2', '2', null, null, null, null), ('2', '2', '2', null, null, null, null), ('3', '3', '3', null, null, null, null), ('4', '3', '3', null, null, null, null), ('5', '3', '3', null, null, null, null), ('6', '2', '2', null, null, null, null), ('7', '2', '2', null, null, null, null), ('10', '3', '555', null, null, '1648858782965', null), ('11', '3', '3', null, null, null, null), ('12', '2', '2', null, null, null, null);
COMMIT;

-- ----------------------------
-- Table structure for stu
-- ----------------------------
DROP TABLE IF EXISTS `stu`;
CREATE TABLE `stu` (
`id`  int NOT NULL AUTO_INCREMENT ,
`name`  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ,
`stu_num`  varchar(222) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ,
`sex`  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ,
`id_num`  varchar(33) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ,
`email`  varchar(33) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
AUTO_INCREMENT=18

;

-- ----------------------------
-- Records of stu
-- ----------------------------
BEGIN;
INSERT INTO `stu` VALUES ('2', '2', null, '男', null, null), ('3', '3', null, '女', null, null), ('4', '4', null, '女', null, null), ('5', '5', null, '男', null, null), ('6', '6', null, '女', null, null), ('7', '7', null, '男', null, null), ('8', '1', null, '女', null, null), ('9', '2', null, '男', null, null), ('10', '3', null, '女', null, null), ('11', '4', null, '男', null, null), ('12', '5', null, '女', null, null), ('13', '6', null, '男', null, null), ('14', 'starplatinumora', '31901077', '男的', '330621199903132999', '250044131314@qq.com'), ('15', '好人', '1111', '男', '1111', '好人@mm.com'), ('16', '好人', '1111', '男', '1111', '好人@mm.com'), ('17', '好人', '1111', '男', '1111', '好人@mm.com');
COMMIT;

-- ----------------------------
-- Auto increment value for article
-- ----------------------------
ALTER TABLE `article` AUTO_INCREMENT=13;

-- ----------------------------
-- Auto increment value for stu
-- ----------------------------
ALTER TABLE `stu` AUTO_INCREMENT=18;
